Dataset statistics
| Number of variables | 49 |
|---|---|
| Number of observations | 416198 |
| Missing cells | 4141442 |
| Missing cells (%) | 20.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 155.6 MiB |
| Average record size in memory | 392.0 B |
Variable types
| CAT | 24 |
|---|---|
| NUM | 15 |
| BOOL | 10 |
Reproduction
| Analysis started | 2020-07-05 20:23:33.277089 |
|---|---|
| Analysis finished | 2020-07-05 20:26:21.939594 |
| Duration | 2 minutes and 48.66 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
RD_NO has a high cardinality: 412429 distinct values | High cardinality |
CRASH_DATE has a high cardinality: 269126 distinct values | High cardinality |
DATE_POLICE_NOTIFIED has a high cardinality: 318866 distinct values | High cardinality |
STREET_NAME has a high cardinality: 1549 distinct values | High cardinality |
LOCATION has a high cardinality: 188585 distinct values | High cardinality |
LONGITUDE is highly correlated with LATITUDE | High correlation |
LATITUDE is highly correlated with LONGITUDE | High correlation |
CRASH_DATE_EST_I has 385362 (92.6%) missing values | Missing |
LANE_CNT has 217643 (52.3%) missing values | Missing |
REPORT_TYPE has 9854 (2.4%) missing values | Missing |
INTERSECTION_RELATED_I has 323233 (77.7%) missing values | Missing |
NOT_RIGHT_OF_WAY_I has 396746 (95.3%) missing values | Missing |
HIT_AND_RUN_I has 298508 (71.7%) missing values | Missing |
PHOTOS_TAKEN_I has 410947 (98.7%) missing values | Missing |
STATEMENTS_TAKEN_I has 407759 (98.0%) missing values | Missing |
DOORING_I has 414845 (99.7%) missing values | Missing |
WORK_ZONE_I has 413389 (99.3%) missing values | Missing |
WORK_ZONE_TYPE has 413971 (99.5%) missing values | Missing |
WORKERS_PRESENT_I has 415527 (99.8%) missing values | Missing |
LANE_CNT is highly skewed (γ1 = 349.9037887) | Skewed |
LATITUDE is highly skewed (γ1 = -109.5963231) | Skewed |
LONGITUDE is highly skewed (γ1 = 118.3356283) | Skewed |
RD_NO is uniformly distributed | Uniform |
CRASH_DATE is uniformly distributed | Uniform |
DATE_POLICE_NOTIFIED is uniformly distributed | Uniform |
CRASH_RECORD_ID has unique values | Unique |
POSTED_SPEED_LIMIT has 6598 (1.6%) zeros | Zeros |
LANE_CNT has 8011 (1.9%) zeros | Zeros |
INJURIES_TOTAL has 362531 (87.1%) zeros | Zeros |
INJURIES_INCAPACITATING has 407047 (97.8%) zeros | Zeros |
INJURIES_NON_INCAPACITATING has 384446 (92.4%) zeros | Zeros |
INJURIES_REPORTED_NOT_EVIDENT has 395564 (95.0%) zeros | Zeros |
INJURIES_NO_INDICATION has 7217 (1.7%) zeros | Zeros |
CRASH_HOUR has 7955 (1.9%) zeros | Zeros |
| Distinct count | 416198 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| ccf9f2e9fb5c877901b61f8067cff682f6fa746fdc595f09fc8bb4b079e5cb3e32875df49e4d9e3553c9822dff8a7199973565bfbdf5404e9acea6439787be58 | 1 |
|---|---|
| 2fae16dee0a81f64460798544a5bfa9d977b7b65ea75f42289cea5cf35ac5e51392e47de98d0b82787fa0a7c9e06652d3f44ee567a029f161a132272b1d102e5 | 1 |
| 111f93bbb4ac656247638ec37f805704286899d863ae2a75625c4e699e6e894c1a4de58ad13cc1cff135acb734b7e8c8db734a44db1f3a14b0dfa72fcb6a7e49 | 1 |
| 1006d04cc120a055579b567edba7e4de622d375fa54344ccdf2e5ecd46bf13c68183f9c28998a770fc56a6e34071ed25802af1dbe842774ebb90cf53ef7b1b74 | 1 |
| b8081464a8348ec2162f25691b7faed02fe150aef5e8bf412fd26ffd7626a8c5a1480ace673d34672b3d08faa6c868ac1df9001b4ad5571d9a2b986e95ef3564 | 1 |
| Other values (416193) |
| Value | Count | Frequency (%) | |
| ccf9f2e9fb5c877901b61f8067cff682f6fa746fdc595f09fc8bb4b079e5cb3e32875df49e4d9e3553c9822dff8a7199973565bfbdf5404e9acea6439787be58 | 1 | < 0.1% | |
| 2fae16dee0a81f64460798544a5bfa9d977b7b65ea75f42289cea5cf35ac5e51392e47de98d0b82787fa0a7c9e06652d3f44ee567a029f161a132272b1d102e5 | 1 | < 0.1% | |
| 111f93bbb4ac656247638ec37f805704286899d863ae2a75625c4e699e6e894c1a4de58ad13cc1cff135acb734b7e8c8db734a44db1f3a14b0dfa72fcb6a7e49 | 1 | < 0.1% | |
| 1006d04cc120a055579b567edba7e4de622d375fa54344ccdf2e5ecd46bf13c68183f9c28998a770fc56a6e34071ed25802af1dbe842774ebb90cf53ef7b1b74 | 1 | < 0.1% | |
| b8081464a8348ec2162f25691b7faed02fe150aef5e8bf412fd26ffd7626a8c5a1480ace673d34672b3d08faa6c868ac1df9001b4ad5571d9a2b986e95ef3564 | 1 | < 0.1% | |
| af746c3cb9c6564ea3aad4b1aab172bd6aae4f2e5979e132b9f1bc212f388dd5e7f9c2bdfe6f93a659ca8836202fd4b7ff0afa25c7b45ae582d00dc94a72f09a | 1 | < 0.1% | |
| a4e02d67c4b7b8feac99c048d74ec89b25b9faf8072b6d9a3ef7dacceae7063cce3b3248aec8a1fda2971016e9b33bb2da6b9202a9349d3e9f4e04f342fc6f10 | 1 | < 0.1% | |
| 32a307bebb1a65450fbfeee9b5215b558c671a20c678575e1f1ce7c5b9a7659dce88d4e48aa93e4a8619499915a990ee2505511e63665c10916343002c322833 | 1 | < 0.1% | |
| 1b14476dbd80f938ac436673297ab6a6f4d46f892e03fb102a817c448bedfdc561b6f8687910f103ae3fc2aa3c0d197261061ce89d83ced8099c654a5a10345d | 1 | < 0.1% | |
| 05f1d2a58eb173c714b4e09a4701940e7ca732359f8359b54880150540eec5b66d28247bf0c48739a209749b9a73e7ad17c260e31285abda6ad8adbdba25d5d1 | 1 | < 0.1% | |
| Other values (416188) | 416188 | > 99.9% |
Length
| Max length | 128 |
|---|---|
| Median length | 128 |
| Mean length | 128 |
| Min length | 128 |
| Distinct count | 412429 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 3769 |
| Missing (%) | 0.9% |
| Memory size | 3.2 MiB |
| JB565226 | 1 |
|---|---|
| JC345846 | 1 |
| JC333602 | 1 |
| JC340011 | 1 |
| HZ279027 | 1 |
| Other values (412424) |
| Value | Count | Frequency (%) | |
| JB565226 | 1 | < 0.1% | |
| JC345846 | 1 | < 0.1% | |
| JC333602 | 1 | < 0.1% | |
| JC340011 | 1 | < 0.1% | |
| HZ279027 | 1 | < 0.1% | |
| JA201464 | 1 | < 0.1% | |
| JC501707 | 1 | < 0.1% | |
| HY510137 | 1 | < 0.1% | |
| JB412006 | 1 | < 0.1% | |
| JB240815 | 1 | < 0.1% | |
| Other values (412419) | 412419 | 99.1% | |
| (Missing) | 3769 | 0.9% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.95472107 |
| Min length | 3 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 385362 |
| Missing (%) | 92.6% |
| Memory size | 3.2 MiB |
| Y | 26728 |
|---|---|
| N | 4108 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 26728 | 6.4% | |
| N | 4108 | 1.0% | |
| (Missing) | 385362 | 92.6% |
| Distinct count | 269126 |
|---|---|
| Unique (%) | 64.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| 11/10/2017 10:30:00 AM | 27 |
|---|---|
| 11/10/2017 10:00:00 AM | 20 |
| 01/12/2019 02:30:00 PM | 20 |
| 01/12/2019 03:00:00 PM | 18 |
| 01/12/2019 02:00:00 PM | 18 |
| Other values (269121) |
| Value | Count | Frequency (%) | |
| 11/10/2017 10:30:00 AM | 27 | < 0.1% | |
| 11/10/2017 10:00:00 AM | 20 | < 0.1% | |
| 01/12/2019 02:30:00 PM | 20 | < 0.1% | |
| 01/12/2019 03:00:00 PM | 18 | < 0.1% | |
| 01/12/2019 02:00:00 PM | 18 | < 0.1% | |
| 02/26/2020 07:45:00 AM | 17 | < 0.1% | |
| 02/26/2020 08:00:00 AM | 16 | < 0.1% | |
| 09/04/2018 08:00:00 AM | 16 | < 0.1% | |
| 01/12/2019 04:00:00 PM | 16 | < 0.1% | |
| 01/25/2018 08:00:00 AM | 15 | < 0.1% | |
| Other values (269116) | 416015 | > 99.9% |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
| Distinct count | 42 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.262797995184982 |
|---|---|
| Minimum | 0 |
| Maximum | 99 |
| Zeros | 6598 |
| Zeros (%) | 1.6% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 30 |
| median | 30 |
| Q3 | 30 |
| 95-th percentile | 35 |
| Maximum | 99 |
| Range | 99 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.591077534 |
|---|---|
| Coefficient of variation (CV) | 0.2332068302 |
| Kurtosis | 8.500474378 |
| Mean | 28.262798 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.918221926 |
| Sum | 11762920 |
| Variance | 43.44230306 |
| Value | Count | Frequency (%) | |
| 30 | 306912 | 73.7% | |
| 35 | 28469 | 6.8% | |
| 25 | 24953 | 6.0% | |
| 20 | 16016 | 3.8% | |
| 15 | 14243 | 3.4% | |
| 10 | 8428 | 2.0% | |
| 0 | 6598 | 1.6% | |
| 40 | 3739 | 0.9% | |
| 5 | 3434 | 0.8% | |
| 45 | 2476 | 0.6% | |
| Other values (32) | 930 | 0.2% |
| Value | Count | Frequency (%) | |
| 0 | 6598 | 1.6% | |
| 1 | 35 | < 0.1% | |
| 2 | 19 | < 0.1% | |
| 3 | 104 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 99 | 67 | < 0.1% | |
| 70 | 3 | < 0.1% | |
| 65 | 9 | < 0.1% | |
| 63 | 1 | < 0.1% | |
| 60 | 26 | < 0.1% |
TRAFFIC_CONTROL_DEVICE
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NO CONTROLS | |
|---|---|
| TRAFFIC SIGNAL | |
| STOP SIGN/FLASHER | 40941 |
| UNKNOWN | 13406 |
| OTHER | 2497 |
| Other values (14) | 3703 |
| Value | Count | Frequency (%) | |
| NO CONTROLS | 239527 | 57.6% | |
| TRAFFIC SIGNAL | 116124 | 27.9% | |
| STOP SIGN/FLASHER | 40941 | 9.8% | |
| UNKNOWN | 13406 | 3.2% | |
| OTHER | 2497 | 0.6% | |
| LANE USE MARKING | 1224 | 0.3% | |
| YIELD | 595 | 0.1% | |
| OTHER REG. SIGN | 400 | 0.1% | |
| OTHER WARNING SIGN | 369 | 0.1% | |
| RAILROAD CROSSING GATE | 286 | 0.1% | |
| Other values (9) | 829 | 0.2% |
Length
| Max length | 24 |
|---|---|
| Median length | 11 |
| Mean length | 12.29793271 |
| Min length | 5 |
DEVICE_CONDITION
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NO CONTROLS | |
|---|---|
| FUNCTIONING PROPERLY | |
| UNKNOWN | 22621 |
| OTHER | 3213 |
| FUNCTIONING IMPROPERLY | 2333 |
| Other values (3) | 1597 |
| Value | Count | Frequency (%) | |
| NO CONTROLS | 241838 | 58.1% | |
| FUNCTIONING PROPERLY | 144596 | 34.7% | |
| UNKNOWN | 22621 | 5.4% | |
| OTHER | 3213 | 0.8% | |
| FUNCTIONING IMPROPERLY | 2333 | 0.6% | |
| NOT FUNCTIONING | 1350 | 0.3% | |
| WORN REFLECTIVE MATERIAL | 192 | < 0.1% | |
| MISSING | 55 | < 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 11 |
| Mean length | 13.94316888 |
| Min length | 5 |
WEATHER_CONDITION
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| CLEAR | |
|---|---|
| RAIN | 38322 |
| UNKNOWN | 17924 |
| SNOW | 15638 |
| CLOUDY/OVERCAST | 12782 |
| Other values (7) | 3310 |
| Value | Count | Frequency (%) | |
| CLEAR | 328222 | 78.9% | |
| RAIN | 38322 | 9.2% | |
| UNKNOWN | 17924 | 4.3% | |
| SNOW | 15638 | 3.8% | |
| CLOUDY/OVERCAST | 12782 | 3.1% | |
| OTHER | 1337 | 0.3% | |
| FOG/SMOKE/HAZE | 782 | 0.2% | |
| SLEET/HAIL | 655 | 0.2% | |
| FREEZING RAIN/DRIZZLE | 384 | 0.1% | |
| SEVERE CROSS WIND GATE | 88 | < 0.1% | |
| Other values (2) | 64 | < 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 5 |
| Mean length | 5.307836655 |
| Min length | 4 |
LIGHTING_CONDITION
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| DAYLIGHT | |
|---|---|
| DARKNESS, LIGHTED ROAD | |
| DARKNESS | 21134 |
| UNKNOWN | 14949 |
| DUSK | 12780 |
| Value | Count | Frequency (%) | |
| DAYLIGHT | 272789 | 65.5% | |
| DARKNESS, LIGHTED ROAD | 87268 | 21.0% | |
| DARKNESS | 21134 | 5.1% | |
| UNKNOWN | 14949 | 3.6% | |
| DUSK | 12780 | 3.1% | |
| DAWN | 7278 | 1.7% |
Length
| Max length | 22 |
|---|---|
| Median length | 8 |
| Mean length | 10.70681503 |
| Min length | 4 |
FIRST_CRASH_TYPE
Categorical
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| REAR END | |
|---|---|
| PARKED MOTOR VEHICLE | |
| SIDESWIPE SAME DIRECTION | |
| TURNING | |
| ANGLE | |
| Other values (13) |
| Value | Count | Frequency (%) | |
| REAR END | 101600 | 24.4% | |
| PARKED MOTOR VEHICLE | 93339 | 22.4% | |
| SIDESWIPE SAME DIRECTION | 66394 | 16.0% | |
| TURNING | 58260 | 14.0% | |
| ANGLE | 43642 | 10.5% | |
| FIXED OBJECT | 18304 | 4.4% | |
| PEDESTRIAN | 9861 | 2.4% | |
| SIDESWIPE OPPOSITE DIRECTION | 6142 | 1.5% | |
| PEDALCYCLIST | 5974 | 1.4% | |
| OTHER OBJECT | 3882 | 0.9% | |
| Other values (8) | 8800 | 2.1% |
Length
| Max length | 28 |
|---|---|
| Median length | 10 |
| Mean length | 13.46485807 |
| Min length | 5 |
TRAFFICWAY_TYPE
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NOT DIVIDED | |
|---|---|
| DIVIDED - W/MEDIAN (NOT RAISED) | |
| ONE-WAY | |
| PARKING LOT | 29929 |
| DIVIDED - W/MEDIAN BARRIER | 25175 |
| Other values (15) |
| Value | Count | Frequency (%) | |
| NOT DIVIDED | 187541 | 45.1% | |
| DIVIDED - W/MEDIAN (NOT RAISED) | 75538 | 18.1% | |
| ONE-WAY | 55263 | 13.3% | |
| PARKING LOT | 29929 | 7.2% | |
| DIVIDED - W/MEDIAN BARRIER | 25175 | 6.0% | |
| OTHER | 12103 | 2.9% | |
| FOUR WAY | 9384 | 2.3% | |
| ALLEY | 6684 | 1.6% | |
| UNKNOWN | 4556 | 1.1% | |
| CENTER TURN LANE | 3696 | 0.9% | |
| Other values (10) | 6329 | 1.5% |
Length
| Max length | 31 |
|---|---|
| Median length | 11 |
| Mean length | 14.67856645 |
| Min length | 4 |
| Distinct count | 41 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 217643 |
| Missing (%) | 52.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.35549847649266 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1191625.0 |
| Zeros | 8011 |
| Zeros (%) | 1.9% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 1191625 |
| Range | 1191625 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2964.985076 |
|---|---|
| Coefficient of variation (CV) | 222.004823 |
| Kurtosis | 134371.3452 |
| Mean | 13.35549848 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 349.9037887 |
| Sum | 2651801 |
| Variance | 8791136.5 |
| Value | Count | Frequency (%) | |
| 2 | 90913 | 21.8% | |
| 4 | 49492 | 11.9% | |
| 1 | 32500 | 7.8% | |
| 3 | 8644 | 2.1% | |
| 0 | 8011 | 1.9% | |
| 6 | 4494 | 1.1% | |
| 5 | 1935 | 0.5% | |
| 8 | 1906 | 0.5% | |
| 7 | 184 | < 0.1% | |
| 10 | 161 | < 0.1% | |
| Other values (31) | 315 | 0.1% | |
| (Missing) | 217643 | 52.3% |
| Value | Count | Frequency (%) | |
| 0 | 8011 | 1.9% | |
| 1 | 32500 | 7.8% | |
| 2 | 90913 | 21.8% | |
| 3 | 8644 | 2.1% | |
| 4 | 49492 | 11.9% |
| Value | Count | Frequency (%) | |
| 1191625 | 1 | < 0.1% | |
| 433634 | 1 | < 0.1% | |
| 299679 | 1 | < 0.1% | |
| 218474 | 1 | < 0.1% | |
| 902 | 1 | < 0.1% |
ALIGNMENT
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| STRAIGHT AND LEVEL | |
|---|---|
| STRAIGHT ON GRADE | 5096 |
| CURVE, LEVEL | 3126 |
| STRAIGHT ON HILLCREST | 1343 |
| CURVE ON GRADE | 615 |
| Value | Count | Frequency (%) | |
| STRAIGHT AND LEVEL | 405811 | 97.5% | |
| STRAIGHT ON GRADE | 5096 | 1.2% | |
| CURVE, LEVEL | 3126 | 0.8% | |
| STRAIGHT ON HILLCREST | 1343 | 0.3% | |
| CURVE ON GRADE | 615 | 0.1% | |
| CURVE ON HILLCREST | 207 | < 0.1% |
Length
| Max length | 21 |
|---|---|
| Median length | 18 |
| Mean length | 17.94646058 |
| Min length | 12 |
ROADWAY_SURFACE_COND
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| DRY | |
|---|---|
| WET | 58746 |
| UNKNOWN | 27285 |
| SNOW OR SLUSH | 14891 |
| ICE | 3393 |
| Other values (2) | 1169 |
| Value | Count | Frequency (%) | |
| DRY | 310714 | 74.7% | |
| WET | 58746 | 14.1% | |
| UNKNOWN | 27285 | 6.6% | |
| SNOW OR SLUSH | 14891 | 3.6% | |
| ICE | 3393 | 0.8% | |
| OTHER | 971 | 0.2% | |
| SAND, MUD, DIRT | 198 | < 0.1% |
Length
| Max length | 15 |
|---|---|
| Median length | 3 |
| Mean length | 3.630392265 |
| Min length | 3 |
ROAD_DEFECT
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NO DEFECTS | |
|---|---|
| UNKNOWN | 59680 |
| RUT, HOLES | 4187 |
| OTHER | 2395 |
| WORN SURFACE | 1709 |
| Other values (2) | 1286 |
| Value | Count | Frequency (%) | |
| NO DEFECTS | 346941 | 83.4% | |
| UNKNOWN | 59680 | 14.3% | |
| RUT, HOLES | 4187 | 1.0% | |
| OTHER | 2395 | 0.6% | |
| WORN SURFACE | 1709 | 0.4% | |
| SHOULDER DEFECT | 910 | 0.2% | |
| DEBRIS ON ROADWAY | 376 | 0.1% |
Length
| Max length | 17 |
|---|---|
| Median length | 10 |
| Mean length | 9.566516418 |
| Min length | 5 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 9854 |
| Missing (%) | 2.4% |
| Memory size | 3.2 MiB |
| NOT ON SCENE (DESK REPORT) | |
|---|---|
| ON SCENE |
| Value | Count | Frequency (%) | |
| NOT ON SCENE (DESK REPORT) | 247133 | 59.4% | |
| ON SCENE | 159211 | 38.3% | |
| (Missing) | 9854 | 2.4% |
Length
| Max length | 26 |
|---|---|
| Median length | 26 |
| Mean length | 18.5697865 |
| Min length | 3 |
CRASH_TYPE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NO INJURY / DRIVE AWAY | |
|---|---|
| INJURY AND / OR TOW DUE TO CRASH |
| Value | Count | Frequency (%) | |
| NO INJURY / DRIVE AWAY | 318202 | 76.5% | |
| INJURY AND / OR TOW DUE TO CRASH | 97996 | 23.5% |
Length
| Max length | 32 |
|---|---|
| Median length | 22 |
| Mean length | 24.3545524 |
| Min length | 22 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 323233 |
| Missing (%) | 77.7% |
| Memory size | 3.2 MiB |
| Y | |
|---|---|
| N | 4407 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 88558 | 21.3% | |
| N | 4407 | 1.1% | |
| (Missing) | 323233 | 77.7% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 396746 |
| Missing (%) | 95.3% |
| Memory size | 3.2 MiB |
| Y | 17769 |
|---|---|
| N | 1683 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 17769 | 4.3% | |
| N | 1683 | 0.4% | |
| (Missing) | 396746 | 95.3% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 298508 |
| Missing (%) | 71.7% |
| Memory size | 3.2 MiB |
| Y | |
|---|---|
| N | 5122 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 112568 | 27.0% | |
| N | 5122 | 1.2% | |
| (Missing) | 298508 | 71.7% |
DAMAGE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| OVER $1,500 | |
|---|---|
| $501 - $1,500 | |
| $500 OR LESS |
| Value | Count | Frequency (%) | |
| OVER $1,500 | 236574 | 56.8% | |
| $501 - $1,500 | 124480 | 29.9% | |
| $500 OR LESS | 55144 | 13.2% |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 11.73067146 |
| Min length | 11 |
| Distinct count | 318866 |
|---|---|
| Unique (%) | 76.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| 02/26/2020 08:30:00 AM | 12 |
|---|---|
| 09/13/2019 05:00:00 PM | 11 |
| 06/30/2018 09:30:00 PM | 11 |
| 01/12/2019 04:30:00 PM | 11 |
| 02/14/2020 05:00:00 PM | 11 |
| Other values (318861) |
| Value | Count | Frequency (%) | |
| 02/26/2020 08:30:00 AM | 12 | < 0.1% | |
| 09/13/2019 05:00:00 PM | 11 | < 0.1% | |
| 06/30/2018 09:30:00 PM | 11 | < 0.1% | |
| 01/12/2019 04:30:00 PM | 11 | < 0.1% | |
| 02/14/2020 05:00:00 PM | 11 | < 0.1% | |
| 05/14/2019 07:00:00 PM | 10 | < 0.1% | |
| 10/25/2017 04:30:00 PM | 10 | < 0.1% | |
| 05/31/2019 04:00:00 PM | 10 | < 0.1% | |
| 05/25/2018 06:00:00 PM | 10 | < 0.1% | |
| 06/03/2019 06:00:00 PM | 10 | < 0.1% | |
| Other values (318856) | 416092 | > 99.9% |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
PRIM_CONTRIBUTORY_CAUSE
Categorical
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| UNABLE TO DETERMINE | |
|---|---|
| FAILING TO YIELD RIGHT-OF-WAY | |
| FOLLOWING TOO CLOSELY | |
| NOT APPLICABLE | 22450 |
| IMPROPER OVERTAKING/PASSING | 20072 |
| Other values (35) |
| Value | Count | Frequency (%) | |
| UNABLE TO DETERMINE | 151188 | 36.3% | |
| FAILING TO YIELD RIGHT-OF-WAY | 46627 | 11.2% | |
| FOLLOWING TOO CLOSELY | 45719 | 11.0% | |
| NOT APPLICABLE | 22450 | 5.4% | |
| IMPROPER OVERTAKING/PASSING | 20072 | 4.8% | |
| IMPROPER BACKING | 18724 | 4.5% | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 17609 | 4.2% | |
| IMPROPER LANE USAGE | 16682 | 4.0% | |
| IMPROPER TURNING/NO SIGNAL | 14033 | 3.4% | |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 12941 | 3.1% | |
| Other values (30) | 50153 | 12.1% |
Length
| Max length | 80 |
|---|---|
| Median length | 19 |
| Mean length | 23.72254552 |
| Min length | 6 |
SEC_CONTRIBUTORY_CAUSE
Categorical
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NOT APPLICABLE | |
|---|---|
| UNABLE TO DETERMINE | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 17536 |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 13368 |
| FAILING TO YIELD RIGHT-OF-WAY | 12833 |
| Other values (35) |
| Value | Count | Frequency (%) | |
| NOT APPLICABLE | 167090 | 40.1% | |
| UNABLE TO DETERMINE | 147957 | 35.5% | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 17536 | 4.2% | |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 13368 | 3.2% | |
| FAILING TO YIELD RIGHT-OF-WAY | 12833 | 3.1% | |
| FOLLOWING TOO CLOSELY | 11846 | 2.8% | |
| IMPROPER OVERTAKING/PASSING | 6243 | 1.5% | |
| IMPROPER LANE USAGE | 6174 | 1.5% | |
| WEATHER | 5338 | 1.3% | |
| IMPROPER TURNING/NO SIGNAL | 4218 | 1.0% | |
| Other values (30) | 23595 | 5.7% |
Length
| Max length | 80 |
|---|---|
| Median length | 19 |
| Mean length | 19.71721152 |
| Min length | 6 |
STREET_NO
Real number (ℝ≥0)
| Distinct count | 10858 |
|---|---|
| Unique (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3602.1317882354074 |
|---|---|
| Minimum | 0 |
| Maximum | 451100 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 133 |
| Q1 | 1200 |
| median | 3119 |
| Q3 | 5504 |
| 95-th percentile | 8755 |
| Maximum | 451100 |
| Range | 451100 |
| Interquartile range (IQR) | 4304 |
Descriptive statistics
| Standard deviation | 2906.652766 |
|---|---|
| Coefficient of variation (CV) | 0.8069257141 |
| Kurtosis | 1349.602701 |
| Mean | 3602.131788 |
| Median Absolute Deviation (MAD) | 2118 |
| Skewness | 9.468342465 |
| Sum | 1499200046 |
| Variance | 8448630.299 |
| Value | Count | Frequency (%) | |
| 100 | 2824 | 0.7% | |
| 1600 | 2614 | 0.6% | |
| 200 | 2534 | 0.6% | |
| 800 | 2502 | 0.6% | |
| 300 | 2345 | 0.6% | |
| 500 | 2249 | 0.5% | |
| 6300 | 2107 | 0.5% | |
| 600 | 2096 | 0.5% | |
| 1200 | 2060 | 0.5% | |
| 4700 | 2029 | 0.5% | |
| Other values (10848) | 392838 | 94.4% |
| Value | Count | Frequency (%) | |
| 0 | 2 | < 0.1% | |
| 1 | 1748 | 0.4% | |
| 2 | 870 | 0.2% | |
| 3 | 278 | 0.1% | |
| 4 | 80 | < 0.1% |
| Value | Count | Frequency (%) | |
| 451100 | 1 | < 0.1% | |
| 34453 | 1 | < 0.1% | |
| 13799 | 3 | < 0.1% | |
| 13780 | 1 | < 0.1% | |
| 13770 | 13 | < 0.1% |
STREET_DIRECTION
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 3.2 MiB |
| W | |
|---|---|
| S | |
| N | |
| E | 28714 |
| Value | Count | Frequency (%) | |
| W | 148717 | 35.7% | |
| S | 136207 | 32.7% | |
| N | 102558 | 24.6% | |
| E | 28714 | 6.9% | |
| (Missing) | 2 | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.000009611 |
| Min length | 1 |
| Distinct count | 1549 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 3.2 MiB |
| WESTERN AVE | 11350 |
|---|---|
| PULASKI RD | 9890 |
| CICERO AVE | 9035 |
| ASHLAND AVE | 8938 |
| HALSTED ST | 7898 |
| Other values (1544) |
| Value | Count | Frequency (%) | |
| WESTERN AVE | 11350 | 2.7% | |
| PULASKI RD | 9890 | 2.4% | |
| CICERO AVE | 9035 | 2.2% | |
| ASHLAND AVE | 8938 | 2.1% | |
| HALSTED ST | 7898 | 1.9% | |
| KEDZIE AVE | 7011 | 1.7% | |
| MICHIGAN AVE | 5764 | 1.4% | |
| STATE ST | 5115 | 1.2% | |
| NORTH AVE | 4948 | 1.2% | |
| CLARK ST | 4933 | 1.2% | |
| Other values (1539) | 341315 | 82.0% |
Length
| Max length | 31 |
|---|---|
| Median length | 10 |
| Mean length | 10.68028438 |
| Min length | 3 |
BEAT_OF_OCCURRENCE
Real number (ℝ≥0)
| Distinct count | 275 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1246.7594775513342 |
|---|---|
| Minimum | 111.0 |
| Maximum | 6100.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 111 |
|---|---|
| 5-th percentile | 124 |
| Q1 | 714 |
| median | 1214 |
| Q3 | 1824 |
| 95-th percentile | 2512 |
| Maximum | 6100 |
| Range | 5989 |
| Interquartile range (IQR) | 1110 |
Descriptive statistics
| Standard deviation | 709.4833482 |
|---|---|
| Coefficient of variation (CV) | 0.5690619249 |
| Kurtosis | -1.018880184 |
| Mean | 1246.759478 |
| Median Absolute Deviation (MAD) | 590 |
| Skewness | 0.1389000038 |
| Sum | 518893814 |
| Variance | 503366.6213 |
| Value | Count | Frequency (%) | |
| 1834 | 5899 | 1.4% | |
| 122 | 4728 | 1.1% | |
| 114 | 4709 | 1.1% | |
| 1831 | 4688 | 1.1% | |
| 813 | 4185 | 1.0% | |
| 815 | 3946 | 0.9% | |
| 833 | 3357 | 0.8% | |
| 2413 | 3213 | 0.8% | |
| 1232 | 3163 | 0.8% | |
| 834 | 3096 | 0.7% | |
| Other values (265) | 375210 | 90.2% |
| Value | Count | Frequency (%) | |
| 111 | 2216 | 0.5% | |
| 112 | 1626 | 0.4% | |
| 113 | 1126 | 0.3% | |
| 114 | 4709 | 1.1% | |
| 121 | 2453 | 0.6% |
| Value | Count | Frequency (%) | |
| 6100 | 1 | < 0.1% | |
| 2535 | 1290 | 0.3% | |
| 2534 | 1702 | 0.4% | |
| 2533 | 2730 | 0.7% | |
| 2532 | 1080 | 0.3% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 410947 |
| Missing (%) | 98.7% |
| Memory size | 3.2 MiB |
| Y | 4085 |
|---|---|
| N | 1166 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 4085 | 1.0% | |
| N | 1166 | 0.3% | |
| (Missing) | 410947 | 98.7% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 407759 |
| Missing (%) | 98.0% |
| Memory size | 3.2 MiB |
| Y | 6850 |
|---|---|
| N | 1589 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 6850 | 1.6% | |
| N | 1589 | 0.4% | |
| (Missing) | 407759 | 98.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 414845 |
| Missing (%) | 99.7% |
| Memory size | 3.2 MiB |
| Y | 926 |
|---|---|
| N | 427 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 926 | 0.2% | |
| N | 427 | 0.1% | |
| (Missing) | 414845 | 99.7% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 413389 |
| Missing (%) | 99.3% |
| Memory size | 3.2 MiB |
| Y | 2227 |
|---|---|
| N | 582 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 2227 | 0.5% | |
| N | 582 | 0.1% | |
| (Missing) | 413389 | 99.3% |
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 413971 |
| Missing (%) | 99.5% |
| Memory size | 3.2 MiB |
| CONSTRUCTION | |
|---|---|
| UNKNOWN | 289 |
| MAINTENANCE | 218 |
| UTILITY | 137 |
| Value | Count | Frequency (%) | |
| CONSTRUCTION | 1583 | 0.4% | |
| UNKNOWN | 289 | 0.1% | |
| MAINTENANCE | 218 | 0.1% | |
| UTILITY | 137 | < 0.1% | |
| (Missing) | 413971 | 99.5% |
Length
| Max length | 12 |
|---|---|
| Median length | 3 |
| Mean length | 3.042515822 |
| Min length | 3 |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 415527 |
| Missing (%) | 99.8% |
| Memory size | 3.2 MiB |
| Y | 605 |
|---|---|
| N | 66 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 605 | 0.1% | |
| N | 66 | < 0.1% | |
| (Missing) | 415527 | 99.8% |
NUM_UNITS
Real number (ℝ≥0)
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1772 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.021509268240892 |
|---|---|
| Minimum | 1.0 |
| Maximum | 18.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4252291736 |
|---|---|
| Coefficient of variation (CV) | 0.2103523245 |
| Kurtosis | 38.4143551 |
| Mean | 2.021509268 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.135685352 |
| Sum | 837766 |
| Variance | 0.1808198501 |
| Value | Count | Frequency (%) | |
| 2 | 365967 | 87.9% | |
| 1 | 23147 | 5.6% | |
| 3 | 20475 | 4.9% | |
| 4 | 3600 | 0.9% | |
| 5 | 851 | 0.2% | |
| 6 | 233 | 0.1% | |
| 7 | 92 | < 0.1% | |
| 8 | 29 | < 0.1% | |
| 9 | 15 | < 0.1% | |
| 10 | 9 | < 0.1% | |
| Other values (5) | 8 | < 0.1% | |
| (Missing) | 1772 | 0.4% |
| Value | Count | Frequency (%) | |
| 1 | 23147 | 5.6% | |
| 2 | 365967 | 87.9% | |
| 3 | 20475 | 4.9% | |
| 4 | 3600 | 0.9% | |
| 5 | 851 | 0.2% |
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| 11 | 3 | < 0.1% |
MOST_SEVERE_INJURY
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2669 |
| Missing (%) | 0.6% |
| Memory size | 3.2 MiB |
| NO INDICATION OF INJURY | |
|---|---|
| NONINCAPACITATING INJURY | 27954 |
| REPORTED, NOT EVIDENT | 16255 |
| INCAPACITATING INJURY | 6439 |
| FATAL | 357 |
| Value | Count | Frequency (%) | |
| NO INDICATION OF INJURY | 362524 | 87.1% | |
| NONINCAPACITATING INJURY | 27954 | 6.7% | |
| REPORTED, NOT EVIDENT | 16255 | 3.9% | |
| INCAPACITATING INJURY | 6439 | 1.5% | |
| FATAL | 357 | 0.1% | |
| (Missing) | 2669 | 0.6% |
Length
| Max length | 24 |
|---|---|
| Median length | 23 |
| Mean length | 22.81441525 |
| Min length | 3 |
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.16713659753927107 |
|---|---|
| Minimum | 0.0 |
| Maximum | 21.0 |
| Zeros | 362531 |
| Zeros (%) | 87.1% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5297513676 |
|---|---|
| Coefficient of variation (CV) | 3.169571329 |
| Kurtosis | 56.39700708 |
| Mean | 0.1671365975 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.267008107 |
| Sum | 69117 |
| Variance | 0.2806365115 |
| Value | Count | Frequency (%) | |
| 0 | 362531 | 87.1% | |
| 1 | 39134 | 9.4% | |
| 2 | 8066 | 1.9% | |
| 3 | 2403 | 0.6% | |
| 4 | 864 | 0.2% | |
| 5 | 317 | 0.1% | |
| 6 | 122 | < 0.1% | |
| 7 | 47 | < 0.1% | |
| 9 | 15 | < 0.1% | |
| 8 | 15 | < 0.1% | |
| Other values (8) | 22 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 362531 | 87.1% | |
| 1 | 39134 | 9.4% | |
| 2 | 8066 | 1.9% | |
| 3 | 2403 | 0.6% | |
| 4 | 864 | 0.2% |
| Value | Count | Frequency (%) | |
| 21 | 2 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 13 | 2 | < 0.1% |
INJURIES_FATAL
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Memory size | 3.2 MiB |
| 0 | |
|---|---|
| 1 | 333 |
| 2 | 20 |
| 3 | 4 |
| Value | Count | Frequency (%) | |
| 0 | 413179 | 99.3% | |
| 1 | 333 | 0.1% | |
| 2 | 20 | < 0.1% | |
| 3 | 4 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01826443163352163 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7.0 |
| Zeros | 407047 |
| Zeros (%) | 97.8% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1580884453 |
|---|---|
| Coefficient of variation (CV) | 8.655535988 |
| Kurtosis | 192.6168951 |
| Mean | 0.01826443163 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.61566853 |
| Sum | 7553 |
| Variance | 0.02499195654 |
| Value | Count | Frequency (%) | |
| 0 | 407047 | 97.8% | |
| 1 | 5713 | 1.4% | |
| 2 | 570 | 0.1% | |
| 3 | 143 | < 0.1% | |
| 4 | 49 | < 0.1% | |
| 5 | 11 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 407047 | 97.8% | |
| 1 | 5713 | 1.4% | |
| 2 | 570 | 0.1% | |
| 3 | 143 | < 0.1% | |
| 4 | 49 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7 | 2 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 11 | < 0.1% | |
| 4 | 49 | < 0.1% | |
| 3 | 143 | < 0.1% |
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09160024762052155 |
|---|---|
| Minimum | 0.0 |
| Maximum | 21.0 |
| Zeros | 384446 |
| Zeros (%) | 92.4% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3898124196 |
|---|---|
| Coefficient of variation (CV) | 4.255582596 |
| Kurtosis | 120.6937507 |
| Mean | 0.09160024762 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.336284575 |
| Sum | 37880 |
| Variance | 0.1519537225 |
| Value | Count | Frequency (%) | |
| 0 | 384446 | 92.4% | |
| 1 | 23281 | 5.6% | |
| 2 | 3975 | 1.0% | |
| 3 | 1169 | 0.3% | |
| 4 | 423 | 0.1% | |
| 5 | 142 | < 0.1% | |
| 6 | 58 | < 0.1% | |
| 7 | 19 | < 0.1% | |
| 8 | 6 | < 0.1% | |
| 10 | 5 | < 0.1% | |
| Other values (6) | 12 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 384446 | 92.4% | |
| 1 | 23281 | 5.6% | |
| 2 | 3975 | 1.0% | |
| 3 | 1169 | 0.3% | |
| 4 | 423 | 0.1% |
| Value | Count | Frequency (%) | |
| 21 | 2 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 11 | 4 | < 0.1% |
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.056340923160256906 |
|---|---|
| Minimum | 0.0 |
| Maximum | 11.0 |
| Zeros | 395564 |
| Zeros (%) | 95.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3022171841 |
|---|---|
| Coefficient of variation (CV) | 5.364079378 |
| Kurtosis | 98.97241035 |
| Mean | 0.05634092316 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.930155486 |
| Sum | 23299 |
| Variance | 0.09133522636 |
| Value | Count | Frequency (%) | |
| 0 | 395564 | 95.0% | |
| 1 | 14222 | 3.4% | |
| 2 | 2729 | 0.7% | |
| 3 | 689 | 0.2% | |
| 4 | 206 | < 0.1% | |
| 5 | 84 | < 0.1% | |
| 6 | 17 | < 0.1% | |
| 7 | 10 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 9 | 5 | < 0.1% | |
| Other values (2) | 5 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 395564 | 95.0% | |
| 1 | 14222 | 3.4% | |
| 2 | 2729 | 0.7% | |
| 3 | 689 | 0.2% | |
| 4 | 206 | < 0.1% |
| Value | Count | Frequency (%) | |
| 11 | 1 | < 0.1% | |
| 10 | 4 | < 0.1% | |
| 9 | 5 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 7 | 10 | < 0.1% |
| Distinct count | 42 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.017824324847172 |
|---|---|
| Minimum | 0.0 |
| Maximum | 61.0 |
| Zeros | 7217 |
| Zeros (%) | 1.7% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 61 |
| Range | 61 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.156723458 |
|---|---|
| Coefficient of variation (CV) | 0.5732528067 |
| Kurtosis | 88.06257539 |
| Mean | 2.017824325 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.289878612 |
| Sum | 834443 |
| Variance | 1.338009157 |
| Value | Count | Frequency (%) | |
| 2 | 198400 | 47.7% | |
| 1 | 122973 | 29.5% | |
| 3 | 51478 | 12.4% | |
| 4 | 19414 | 4.7% | |
| 5 | 8103 | 1.9% | |
| 0 | 7217 | 1.7% | |
| 6 | 3434 | 0.8% | |
| 7 | 1306 | 0.3% | |
| 8 | 596 | 0.1% | |
| 9 | 242 | 0.1% | |
| Other values (32) | 373 | 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 7217 | 1.7% | |
| 1 | 122973 | 29.5% | |
| 2 | 198400 | 47.7% | |
| 3 | 51478 | 12.4% | |
| 4 | 19414 | 4.7% |
| Value | Count | Frequency (%) | |
| 61 | 1 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 42 | 3 | < 0.1% | |
| 40 | 2 | < 0.1% |
INJURIES_UNKNOWN
Boolean
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Memory size | 3.2 MiB |
| 0 | |
|---|---|
| (Missing) | 2662 |
| Value | Count | Frequency (%) | |
| 0 | 413536 | 99.4% | |
| (Missing) | 2662 | 0.6% |
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.192122499387311 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros | 7955 |
| Zeros (%) | 1.9% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 9 |
| median | 14 |
| Q3 | 17 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.466229452 |
|---|---|
| Coefficient of variation (CV) | 0.4143555711 |
| Kurtosis | -0.3949940867 |
| Mean | 13.1921225 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.3972465967 |
| Sum | 5490535 |
| Variance | 29.87966442 |
| Value | Count | Frequency (%) | |
| 16 | 31862 | 7.7% | |
| 15 | 31777 | 7.6% | |
| 17 | 31499 | 7.6% | |
| 14 | 28035 | 6.7% | |
| 18 | 25945 | 6.2% | |
| 13 | 25468 | 6.1% | |
| 12 | 24434 | 5.9% | |
| 8 | 23482 | 5.6% | |
| 11 | 21028 | 5.1% | |
| 9 | 20013 | 4.8% | |
| Other values (14) | 152655 | 36.7% |
| Value | Count | Frequency (%) | |
| 0 | 7955 | 1.9% | |
| 1 | 6789 | 1.6% | |
| 2 | 6029 | 1.4% | |
| 3 | 4973 | 1.2% | |
| 4 | 4621 | 1.1% |
| Value | Count | Frequency (%) | |
| 23 | 10014 | 2.4% | |
| 22 | 12149 | 2.9% | |
| 21 | 13130 | 3.2% | |
| 20 | 14633 | 3.5% | |
| 19 | 18707 | 4.5% |
CRASH_DAY_OF_WEEK
Real number (ℝ≥0)
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.124536879081591 |
|---|---|
| Minimum | 1 |
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.969188807 |
|---|---|
| Coefficient of variation (CV) | 0.477432707 |
| Kurtosis | -1.23070302 |
| Mean | 4.124536879 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.0721495666 |
| Sum | 1716624 |
| Variance | 3.877704559 |
| Value | Count | Frequency (%) | |
| 6 | 67592 | 16.2% | |
| 7 | 60950 | 14.6% | |
| 3 | 60300 | 14.5% | |
| 5 | 59884 | 14.4% | |
| 4 | 59524 | 14.3% | |
| 2 | 58058 | 13.9% | |
| 1 | 49890 | 12.0% |
| Value | Count | Frequency (%) | |
| 1 | 49890 | 12.0% | |
| 2 | 58058 | 13.9% | |
| 3 | 60300 | 14.5% | |
| 4 | 59524 | 14.3% | |
| 5 | 59884 | 14.4% |
| Value | Count | Frequency (%) | |
| 7 | 60950 | 14.6% | |
| 6 | 67592 | 16.2% | |
| 5 | 59884 | 14.4% | |
| 4 | 59524 | 14.3% | |
| 3 | 60300 | 14.5% |
CRASH_MONTH
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.601134556148756 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.469570701 |
|---|---|
| Coefficient of variation (CV) | 0.5256021782 |
| Kurtosis | -1.224863741 |
| Mean | 6.601134556 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.03463350759 |
| Sum | 2747379 |
| Variance | 12.03792085 |
| Value | Count | Frequency (%) | |
| 10 | 38043 | 9.1% | |
| 6 | 37690 | 9.1% | |
| 12 | 36913 | 8.9% | |
| 5 | 36717 | 8.8% | |
| 11 | 35832 | 8.6% | |
| 9 | 34951 | 8.4% | |
| 1 | 34372 | 8.3% | |
| 3 | 33651 | 8.1% | |
| 2 | 32917 | 7.9% | |
| 8 | 32646 | 7.8% | |
| Other values (2) | 62466 | 15.0% |
| Value | Count | Frequency (%) | |
| 1 | 34372 | 8.3% | |
| 2 | 32917 | 7.9% | |
| 3 | 33651 | 8.1% | |
| 4 | 31344 | 7.5% | |
| 5 | 36717 | 8.8% |
| Value | Count | Frequency (%) | |
| 12 | 36913 | 8.9% | |
| 11 | 35832 | 8.6% | |
| 10 | 38043 | 9.1% | |
| 9 | 34951 | 8.4% | |
| 8 | 32646 | 7.8% |
| Distinct count | 188507 |
|---|---|
| Unique (%) | 45.5% |
| Missing | 2269 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.85715475635502 |
|---|---|
| Minimum | 0.0 |
| Maximum | 42.022779861 |
| Zeros | 29 |
| Zeros (%) | < 0.1% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 41.71443216 |
| Q1 | 41.78658293 |
| median | 41.877441 |
| Q3 | 41.92475429 |
| 95-th percentile | 41.9903545 |
| Maximum | 42.02277986 |
| Range | 42.02277986 |
| Interquartile range (IQR) | 0.13817136 |
Descriptive statistics
| Standard deviation | 0.3605778004 |
|---|---|
| Coefficient of variation (CV) | 0.008614484251 |
| Kurtosis | 12719.21078 |
| Mean | 41.85715476 |
| Median Absolute Deviation (MAD) | 0.06766827 |
| Skewness | -109.5963231 |
| Sum | 17325890.21 |
| Variance | 0.1300163502 |
| Value | Count | Frequency (%) | |
| 41.97620114 | 553 | 0.1% | |
| 41.79142028 | 274 | 0.1% | |
| 41.7514606 | 270 | 0.1% | |
| 41.72225727 | 223 | 0.1% | |
| 41.78932932 | 204 | < 0.1% | |
| 41.75466012 | 194 | < 0.1% | |
| 41.90095892 | 177 | < 0.1% | |
| 41.74257762 | 151 | < 0.1% | |
| 41.73638005 | 147 | < 0.1% | |
| 41.79291088 | 141 | < 0.1% | |
| Other values (188497) | 411595 | 98.9% | |
| (Missing) | 2269 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 29 | < 0.1% | |
| 41.64467013 | 11 | < 0.1% | |
| 41.64469152 | 2 | < 0.1% | |
| 41.64469397 | 5 | < 0.1% | |
| 41.64470194 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 42.02277986 | 3 | < 0.1% | |
| 42.02273632 | 1 | < 0.1% | |
| 42.02272017 | 1 | < 0.1% | |
| 42.02266893 | 1 | < 0.1% | |
| 42.02266114 | 2 | < 0.1% |
| Distinct count | 188492 |
|---|---|
| Unique (%) | 45.5% |
| Missing | 2269 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.6721175590124 |
|---|---|
| Minimum | -87.934014222 |
| Maximum | 0.0 |
| Zeros | 29 |
| Zeros (%) | < 0.1% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | -87.93401422 |
|---|---|
| 5-th percentile | -87.77636157 |
| Q1 | -87.72079453 |
| median | -87.67297631 |
| Q3 | -87.63296444 |
| 95-th percentile | -87.58608853 |
| Maximum | 0 |
| Range | 87.93401422 |
| Interquartile range (IQR) | 0.087830094 |
Descriptive statistics
| Standard deviation | 0.7361749743 |
|---|---|
| Coefficient of variation (CV) | -0.008396911069 |
| Kurtosis | 14089.92941 |
| Mean | -87.67211756 |
| Median Absolute Deviation (MAD) | 0.042428613 |
| Skewness | 118.3356283 |
| Sum | -36290031.95 |
| Variance | 0.5419535928 |
| Value | Count | Frequency (%) | |
| -87.90530913 | 553 | 0.1% | |
| -87.58014777 | 274 | 0.1% | |
| -87.58597199 | 270 | 0.1% | |
| -87.58527557 | 223 | 0.1% | |
| -87.74164564 | 204 | < 0.1% | |
| -87.74138476 | 194 | < 0.1% | |
| -87.61992817 | 177 | < 0.1% | |
| -87.63393693 | 151 | < 0.1% | |
| -87.62750922 | 147 | < 0.1% | |
| -87.74207734 | 141 | < 0.1% | |
| Other values (188482) | 411595 | 98.9% | |
| (Missing) | 2269 | 0.5% |
| Value | Count | Frequency (%) | |
| -87.93401422 | 1 | < 0.1% | |
| -87.93399393 | 15 | < 0.1% | |
| -87.9339765 | 1 | < 0.1% | |
| -87.93302828 | 2 | < 0.1% | |
| -87.92726168 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 29 | < 0.1% | |
| -87.52458739 | 3 | < 0.1% | |
| -87.52458901 | 2 | < 0.1% | |
| -87.52464032 | 1 | < 0.1% | |
| -87.52467395 | 4 | < 0.1% |
| Distinct count | 188585 |
|---|---|
| Unique (%) | 45.6% |
| Missing | 2269 |
| Missing (%) | 0.5% |
| Memory size | 3.2 MiB |
| POINT (-87.905309125103 41.976201139024) | 553 |
|---|---|
| POINT (-87.580147768689 41.791420282098) | 274 |
| POINT (-87.585971992965 41.751460603167) | 270 |
| POINT (-87.585275565077 41.722257273006) | 223 |
| POINT (-87.741645644196 41.789329323265) | 204 |
| Other values (188580) |
| Value | Count | Frequency (%) | |
| POINT (-87.905309125103 41.976201139024) | 553 | 0.1% | |
| POINT (-87.580147768689 41.791420282098) | 274 | 0.1% | |
| POINT (-87.585971992965 41.751460603167) | 270 | 0.1% | |
| POINT (-87.585275565077 41.722257273006) | 223 | 0.1% | |
| POINT (-87.741645644196 41.789329323265) | 204 | < 0.1% | |
| POINT (-87.741384758605 41.754660124394) | 194 | < 0.1% | |
| POINT (-87.619928173678 41.900958919109) | 177 | < 0.1% | |
| POINT (-87.633936930688 41.742577617335) | 151 | < 0.1% | |
| POINT (-87.627509219026 41.736380045588) | 147 | < 0.1% | |
| POINT (-87.742077342959 41.792910883497) | 141 | < 0.1% | |
| Other values (188575) | 411595 | 98.9% | |
| (Missing) | 2269 | 0.5% |
Length
| Max length | 40 |
|---|---|
| Median length | 40 |
| Mean length | 39.57757846 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| CRASH_RECORD_ID | RD_NO | CRASH_DATE_EST_I | CRASH_DATE | POSTED_SPEED_LIMIT | TRAFFIC_CONTROL_DEVICE | DEVICE_CONDITION | WEATHER_CONDITION | LIGHTING_CONDITION | FIRST_CRASH_TYPE | TRAFFICWAY_TYPE | LANE_CNT | ALIGNMENT | ROADWAY_SURFACE_COND | ROAD_DEFECT | REPORT_TYPE | CRASH_TYPE | INTERSECTION_RELATED_I | NOT_RIGHT_OF_WAY_I | HIT_AND_RUN_I | DAMAGE | DATE_POLICE_NOTIFIED | PRIM_CONTRIBUTORY_CAUSE | SEC_CONTRIBUTORY_CAUSE | STREET_NO | STREET_DIRECTION | STREET_NAME | BEAT_OF_OCCURRENCE | PHOTOS_TAKEN_I | STATEMENTS_TAKEN_I | DOORING_I | WORK_ZONE_I | WORK_ZONE_TYPE | WORKERS_PRESENT_I | NUM_UNITS | MOST_SEVERE_INJURY | INJURIES_TOTAL | INJURIES_FATAL | INJURIES_INCAPACITATING | INJURIES_NON_INCAPACITATING | INJURIES_REPORTED_NOT_EVIDENT | INJURIES_NO_INDICATION | INJURIES_UNKNOWN | CRASH_HOUR | CRASH_DAY_OF_WEEK | CRASH_MONTH | LATITUDE | LONGITUDE | LOCATION | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 073682ef84ff827659552d4254ad1b98bfec24935cc9cc4cbb796b0d17f98ce6028f4ac1795c51cdfa6cb6933de709f33cfe5171c175e4a0f5aebda62f2f61ce | JB460108 | NaN | 10/02/2018 06:30:00 PM | 10 | NO CONTROLS | NO CONTROLS | CLEAR | DARKNESS | PARKED MOTOR VEHICLE | OTHER | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | NaN | NaN | OVER $1,500 | 10/02/2018 07:35:00 PM | NOT APPLICABLE | NOT APPLICABLE | 517 | W | OHARE ST | 1654.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 18 | 3 | 10 | NaN | NaN | NaN |
| 1 | 1560fb8a1e32b528fef8bfd677d2b3fc5ab37278b157fa5ecf66064359bdad3803b9d298d234eb31f463d08515c791b5627fbf7afea3765d1c1a9f3befc5bdcc | JC325941 | NaN | 06/27/2019 04:00:00 PM | 45 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | ONE-WAY | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | NaN | NaN | OVER $1,500 | 06/27/2019 04:00:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 3 | W | TERMINAL ST | 1653.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 16 | 5 | 6 | NaN | NaN | NaN |
| 2 | 009e9e67203442370272e1a13d6ee51a4155dac65e583d1bdbee1fde686de7508c14ab5f205402f72644001276718917e02985561dc71b7d4bf945f09d7d47f5 | JA329216 | NaN | 06/30/2017 04:00:00 PM | 35 | STOP SIGN/FLASHER | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | NOT DIVIDED | 4.0 | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | Y | NaN | NaN | OVER $1,500 | 06/30/2017 04:01:00 PM | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 8301 | S | CICERO AVE | 834.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 16 | 6 | 6 | 41.741804 | -87.740954 | POINT (-87.740953581987 41.741803598989) |
| 3 | 00e47f189660cd8ba1e85fc63061bf1d8465184393f134fb8251ed7896a4ba9ed7c984ab51a01f564d6f4133c6ef8493b1a369743a4a308d4392900a286e160f | JC194776 | NaN | 03/21/2019 10:50:00 PM | 30 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DARKNESS, LIGHTED ROAD | TURNING | NOT DIVIDED | 4.0 | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | Y | NaN | NaN | OVER $1,500 | 03/21/2019 10:52:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 8301 | S | CICERO AVE | 834.0 | NaN | Y | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 22 | 5 | 3 | 41.741804 | -87.740954 | POINT (-87.740953581987 41.741803598989) |
| 4 | 0126747fc9ffc0edc9a38abb83d80034f897db0f739eef57f9bc75de8f2702a4c8f6dd8e49f5c2e810e1ec428bd9532fd0e6c583ca72669da9e65fc2a0a6de12 | JB200478 | NaN | 03/26/2018 02:23:00 PM | 35 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | PARKED MOTOR VEHICLE | NOT DIVIDED | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | NaN | $501 - $1,500 | 03/26/2018 03:20:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 3999 | N | AVONDALE AVE | 1732.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 14 | 2 | 3 | 41.953647 | -87.732082 | POINT (-87.732081736006 41.953646899951) |
| 5 | 5d672ce84d5b78346be822b388604bdf9cb3fa348a5adc89501859f857e1e9308e35ececb0a56527c6e6d065cc85e4e93302c1c57a97068034116e8b23ec2f4e | JD158927 | NaN | 02/20/2020 04:45:00 PM | 35 | TRAFFIC SIGNAL | OTHER | CLEAR | DAWN | REAR END | T-INTERSECTION | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | Y | NaN | NaN | $501 - $1,500 | 02/20/2020 04:51:00 PM | NOT APPLICABLE | NOT APPLICABLE | 12300 | W | IRVING PARK RD | 1654.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 16 | 5 | 2 | 41.958987 | -87.933994 | POINT (-87.933993928974 41.958986950953) |
| 6 | 0209e21f298984f7375742b7ef27c9880b485f41123a12b5a8eb14f01171abbbc05974399b985e05a352f801869cae0f41587f39a51994338fb82aeba853eece | JB415436 | NaN | 08/30/2018 05:45:00 PM | 30 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | NOT DIVIDED | NaN | STRAIGHT AND LEVEL | DRY | UNKNOWN | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | Y | NaN | NaN | OVER $1,500 | 08/30/2018 05:58:00 PM | IMPROPER OVERTAKING/PASSING | IMPROPER LANE USAGE | 600 | W | DIVISION ST | 1822.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 17 | 5 | 8 | 41.903825 | -87.643286 | POINT (-87.643286359995 41.903825233976) |
| 7 | 0211e1f766f3940dfa87375661d25b716655e908c320cc46910e8fa5fb1f1e6a9d4f714d21e8e401ec9e0a12190b6cd9f6dbc97d32d0c0fc966a02ae516e782f | JC301403 | NaN | 06/11/2019 08:40:00 AM | 30 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | REAR END | DIVIDED - W/MEDIAN BARRIER | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | Y | NaN | NaN | $501 - $1,500 | 06/11/2019 09:05:00 AM | UNABLE TO DETERMINE | NOT APPLICABLE | 50 | E | GARFIELD BLVD | 225.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 8 | 3 | 6 | 41.794779 | -87.623828 | POINT (-87.623828038036 41.794778764028) |
| 8 | 02e2ed3606a50dda185f5e97c57a45552087d6fbea1c4b5f3777e0503da72279211f0518aabbeca2cd8e8ee1aca6cae3f88a0531cb62bb39ac156ca3d55e0931 | JB256393 | NaN | 05/09/2018 11:30:00 AM | 25 | NO CONTROLS | NO CONTROLS | RAIN | DAYLIGHT | ANGLE | NOT DIVIDED | 2.0 | STRAIGHT AND LEVEL | WET | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | NaN | NaN | OVER $1,500 | 05/09/2018 11:35:00 AM | FAILING TO YIELD RIGHT-OF-WAY | UNABLE TO DETERMINE | 9511 | S | WENTWORTH AVE | 511.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 11 | 4 | 5 | 41.721290 | -87.628510 | POINT (-87.628509593966 41.72128957001) |
| 9 | 03c8fee8a0cb0d303e972a873228b444a47b7b1ed1e2d97a8c409203dc81a9d97abc26692d325af7428a2f8f880ab0e551e763782226b9b6a0c3e19abd7ffa23 | JB317419 | NaN | 06/22/2018 07:25:00 AM | 35 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | RAIN | DAYLIGHT | TURNING | NOT DIVIDED | 6.0 | STRAIGHT AND LEVEL | WET | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | Y | NaN | NaN | OVER $1,500 | 06/22/2018 07:27:00 AM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 8301 | S | CICERO AVE | 834.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NONINCAPACITATING INJURY | 2.0 | 0.0 | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | 7 | 6 | 6 | 41.741804 | -87.740954 | POINT (-87.740953581987 41.741803598989) |
Last rows
| CRASH_RECORD_ID | RD_NO | CRASH_DATE_EST_I | CRASH_DATE | POSTED_SPEED_LIMIT | TRAFFIC_CONTROL_DEVICE | DEVICE_CONDITION | WEATHER_CONDITION | LIGHTING_CONDITION | FIRST_CRASH_TYPE | TRAFFICWAY_TYPE | LANE_CNT | ALIGNMENT | ROADWAY_SURFACE_COND | ROAD_DEFECT | REPORT_TYPE | CRASH_TYPE | INTERSECTION_RELATED_I | NOT_RIGHT_OF_WAY_I | HIT_AND_RUN_I | DAMAGE | DATE_POLICE_NOTIFIED | PRIM_CONTRIBUTORY_CAUSE | SEC_CONTRIBUTORY_CAUSE | STREET_NO | STREET_DIRECTION | STREET_NAME | BEAT_OF_OCCURRENCE | PHOTOS_TAKEN_I | STATEMENTS_TAKEN_I | DOORING_I | WORK_ZONE_I | WORK_ZONE_TYPE | WORKERS_PRESENT_I | NUM_UNITS | MOST_SEVERE_INJURY | INJURIES_TOTAL | INJURIES_FATAL | INJURIES_INCAPACITATING | INJURIES_NON_INCAPACITATING | INJURIES_REPORTED_NOT_EVIDENT | INJURIES_NO_INDICATION | INJURIES_UNKNOWN | CRASH_HOUR | CRASH_DAY_OF_WEEK | CRASH_MONTH | LATITUDE | LONGITUDE | LOCATION | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 416188 | e03b02d64d5d4db07c0c24fe1e9c495b4ac5b67cbe1e7334d16533b47b2a410bf1481830ec85ab046c4b391bf689476f68af6df1437f9e21cd10cacb10f7308a | JD236641 | NaN | 05/19/2020 01:00:00 PM | 25 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | REAR END | ONE-WAY | NaN | STRAIGHT AND LEVEL | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | Y | $501 - $1,500 | 05/19/2020 02:30:00 PM | NOT APPLICABLE | NOT APPLICABLE | 1000 | S | KOLMAR AVE | 1131.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 13 | 3 | 5 | 41.869118 | -87.739401 | POINT (-87.739401314183 41.869117777281) |
| 416189 | f198c65371434926c14b2a63ed8792a1389fadaf675d8ee368dc5aaf1a30467a894c1412b2f099985c04308755ad76dfd1589de86c674ff6050c527539baee0d | JD236802 | NaN | 05/19/2020 03:31:00 PM | 30 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | FOUR WAY | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | Y | NaN | NaN | $501 - $1,500 | 05/19/2020 03:51:00 PM | IMPROPER TURNING/NO SIGNAL | NOT APPLICABLE | 2001 | E | MARQUETTE DR | 331.0 | NaN | NaN | NaN | Y | CONSTRUCTION | N | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 15 | 3 | 5 | 41.775563 | -87.576444 | POINT (-87.576444451178 41.775562727526) |
| 416190 | f52f00333e5cac1530939b110da25a72de89372c032ae422467081eb937a8ff841ff2f5d73c28ededd41b765fad1e5681c1b039b5c02435bb9edb9ee97c94eab | JD236940 | NaN | 05/19/2020 06:21:00 PM | 30 | NO CONTROLS | NO CONTROLS | CLOUDY/OVERCAST | DAYLIGHT | SIDESWIPE SAME DIRECTION | DIVIDED - W/MEDIAN (NOT RAISED) | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | NaN | NaN | $500 OR LESS | 05/19/2020 06:21:00 PM | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 2473 | N | CLARK ST | 1935.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 18 | 3 | 5 | 41.927478 | -87.641450 | POINT (-87.641449775903 41.927477726852) |
| 416191 | d97477e587b8eecbdb0dbce0a0c5462e7335a4f7da2e04c8e4799193cba69f0b887de56a831e8899031c1f7175e82a2ad8c43ba34260181a3e4e1bafda37ea88 | JD234027 | NaN | 05/16/2020 11:45:00 AM | 40 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | DIVIDED - W/MEDIAN BARRIER | NaN | CURVE, LEVEL | DRY | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | NaN | NaN | NaN | OVER $1,500 | 05/16/2020 11:55:00 AM | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 120 | N | LAKE SHORE DR SB | 114.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 11 | 7 | 5 | 41.883642 | -87.615441 | POINT (-87.615441182232 41.883641778749) |
| 416192 | e43ffefbcb0c4518869aac0447be15af688b10f56d652adb93a204fc18d823594c6cf5e64bcf12134ee2e91a692e0434118a1367b5a5904e448f4cdbc850bfb5 | JD234946 | NaN | 05/17/2020 01:22:00 PM | 30 | NO CONTROLS | NO CONTROLS | RAIN | DAYLIGHT | PARKED MOTOR VEHICLE | DIVIDED - W/MEDIAN BARRIER | NaN | STRAIGHT AND LEVEL | WET | UNKNOWN | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | NaN | NaN | NaN | $501 - $1,500 | 05/17/2020 01:22:00 PM | IMPROPER LANE USAGE | FAILING TO REDUCE SPEED TO AVOID CRASH | 1924 | W | GARFIELD BLVD | 932.0 | NaN | NaN | NaN | NaN | NaN | NaN | 3.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 13 | 1 | 5 | 41.794040 | -87.673019 | POINT (-87.673018619292 41.79403960152) |
| 416193 | de4cbde297443228427759c6d58f40254dc8d8fcb201dc731da85d4d0dcd05fd2fbb10974bc0d17cdecd4128959af5b2fc2a4b8a0ee42f3370be201aba68a5bd | JD235651 | NaN | 05/18/2020 12:20:00 PM | 10 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | REAR TO SIDE | PARKING LOT | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | NaN | $500 OR LESS | 05/18/2020 12:32:00 PM | FAILING TO YIELD RIGHT-OF-WAY | UNABLE TO DETERMINE | 1527 | W | LAWRENCE AVE | 1912.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 12 | 2 | 5 | 41.968773 | -87.668624 | POINT (-87.668624408172 41.968772794281) |
| 416194 | eb65bb1c2f912fbd1a80406813bbe831df2083d483334697387d443e911400cfad731b727f3ab2ab982ab9583e12ef1bba31838e50a2d4c3979a28223b8ef00f | JD235725 | NaN | 05/18/2020 09:00:00 AM | 30 | UNKNOWN | UNKNOWN | UNKNOWN | UNKNOWN | PARKED MOTOR VEHICLE | UNKNOWN | NaN | STRAIGHT AND LEVEL | UNKNOWN | UNKNOWN | NOT ON SCENE (DESK REPORT) | INJURY AND / OR TOW DUE TO CRASH | NaN | NaN | Y | OVER $1,500 | 05/18/2020 01:48:00 PM | UNABLE TO DETERMINE | NOT APPLICABLE | 4015 | N | PARKSIDE AVE | 1624.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 9 | 2 | 5 | 41.953658 | -87.768095 | POINT (-87.768095363598 41.953657967626) |
| 416195 | d35263055740651327a467ea3b5181fde21e1edad1e917c4096a7ca360f3ef47a2d3dc69666c6fc9bdfe7a9fdf8420654f251fcdf7c657bddc51a3a263e6eaf5 | JD236504 | NaN | 05/19/2020 02:00:00 AM | 20 | NO CONTROLS | NO CONTROLS | RAIN | DARKNESS, LIGHTED ROAD | PARKED MOTOR VEHICLE | ONE-WAY | NaN | STRAIGHT AND LEVEL | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | NaN | $500 OR LESS | 05/19/2020 11:00:00 AM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 5700 | N | RICHMOND ST | 2011.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 2 | 3 | 5 | 41.985008 | -87.703007 | POINT (-87.70300710512 41.985008248097) |
| 416196 | d613f48076a4221ebaebf9fc31bf396baaf18892529f3f97474e6795d01eb9545440ed9dc0d31201c554798cce001416f0aff7f4214f3848bdb211d8f89915af | JD236487 | NaN | 05/19/2020 09:40:00 AM | 30 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | PARKED MOTOR VEHICLE | NOT DIVIDED | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | NaN | $501 - $1,500 | 05/19/2020 10:36:00 AM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 7715 | S | COTTAGE GROVE AVE | 624.0 | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 9 | 3 | 5 | 41.754447 | -87.605136 | POINT (-87.605136112415 41.75444668619) |
| 416197 | f247683bbffde5cd7d1bddad30ff42c2d3d4594ffd218dc9bdbb270b88edac4d3e2c87a077ea21bede21d27eb2d508c8c9e0a42595a81d1221035e85aeea04cd | JD236796 | NaN | 05/19/2020 01:32:00 PM | 10 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | OTHER OBJECT | ALLEY | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | NaN | OVER $1,500 | 05/19/2020 03:46:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 925 | S | INDEPENDENCE BLVD | 1133.0 | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 13 | 3 | 5 | 41.869263 | -87.719477 | POINT (-87.719476770345 41.869263306188) |